So in the previous two lectures we talked about importing data into Excel.
Now the reverse is also possible within Excel.
I don't want to employ.
But I want to take some existing Excel data and export it to some other format perhaps I want to export
it into a text file so that I can then import that into some other system.
So open in front of you I've got our standard exercise file one that comes with this course again bailable
next year number two if you haven't downloaded it already.
I'm on the employee records worksheet and I decide you know what I'm going to take it from Excel and
I'm going to export this into a text file.
That way I can work with this inside of other systems if I like.
Maybe back into Access or back in the crystal reports or some other database tool out there that I want
to be able to work with this data within.
Or perhaps I'm going through a migration.
Data is just too big for Excel.
Let's move it someplace else where we can get a little bit more of a robust system for larger amounts
of data.
So just like importing super simple simple even probably even more simple than importing exporting is
really just the Save As.
Take a look.
So I'm in the exercise file employee records worksheet.
I'm going to go up to my File tab on my File tab I go down the save as I'm going to save it to my one
drive account into my exercise files.
And right now defaults.
Now if I were to save it right now I just save it out as an Excel document but I may change it from
Excel.
I'm going to go to a text format and I'm going to do a text tab delimited.
This is the first exercise we did with importing data.
It was a tab delimited file.
I'll grab that.
I'm going to give it a different name because I've already got one there.
I just put it to do that and I'll save it.
And I'd now export did that file Excel file to attend delimited file.
Now it does bring up a prompt here telling me that hey the select the file type the tab delimited file
type is saved as does NOT support workbooks that contain more worksheets.
That's OK.
I'm only want employee records.
I want good summary and all the rest of them.
OK.
Some features in the workbook may be lost because it's a text handling file meaning that any of the
extra formatting and like my bold and blue and underly that stuff won't go through because this is a
simple text file.
So I go in and say well that's fine I was going to say yes.
And I've now created this tab delimited text file.
Let me open it up here in front of you.
And I just saved it out to my exercise files folder on my computer.
I'll give that a double click.
It's asked me here how do I want to open up this document I'm going to open it up and send a notepad
.
And here it is.
But I've taken that Excel worksheet the one worksheet exported out into a tab delimited text files and
you can see that each column is separated by a tab.
Is this character right out of here.
So again what we do is for well I want to really take the data from Excel and export it out to text
so that I can then turn around and perhaps imported into some other system that allows for imports from
textfiles again.
Super simple.
When you do an export from Excel it's just the same as say there's.
Pick your file type whether it's text have delimited or cxxviii file.
And each time I'll document whatever it is it's just a simple Save As.
Try it out.
Open up our exercise file up to File Save As save it out as one of the formats doesn't have to be tabbed
to limit it but what ever you want to try.
Whatever catches your eye or may maybe more relevant for you.
Tax is just a very popular one.
So try it out